James Keuning — Smartsheet Community

Skip to content

Overview

Overview
Roles	Member
Badges	22

About Me

About Me
Country	United States
How I Use Smartsheet	We use Smartsheet to support various functions in a law firm. We started using it as the PMIS for our PMO but have expanded into supporting lawyers and their clients. The collaborators are free model is the feature that attracted me to Smartsheet, but after several years, I have no reason to leave. We use Data Shuttle to move data in and out of our various systems, and along with Power Automate and Power BI, we find that it can do most of what we need.

Analytics

492

Posts

626

Visits

935

Points

Oct 5, 2020

Join Date

Feb 28, 2025

Last Active

Re: Is there a way to tell what sheet a form is connected to?

James Keuning

01/18/23

I user the form to submit a new record, and enter something like aaabbbccc and then search for that value. It's really run if you have workflow that moves records around, because that value will show…

2 ·
Re: "Alert Someone" Send to Contacts in a Cell NOT WORKING/Send to Specific People WORKING

James Keuning

03/12/22

Are the failed recipients getting any alerts from other Smartsheet workflows? Have you check alert settings? Maybe at the account level?

1 ·
Re: Is there a workaround that would equate to the IN Operator in MS Access?

James Keuning

05/08/22

You don't need to use multiple IF statements, you could use one IF along with an OR statement. Or you create a lookup sheet with a list of the 17 choices, and then a column with data that is either b…

1 ·
Re: An automated workflow where data is updated to an existing sheet

James Keuning

05/07/22

The nomenclature "Form" is a specific thing in Smartsheet, and is a mechanism for creating a new record. And "Workflow" is also a thing - Smartsheet's lingo for Automation. That l…

1 ·
Re: How to show blank where no data is, when using =MAX(0, NETWORKDAYS(TODAY(), End@row))

James Keuning

05/06/22

iferror(MAX(0, NETWORKDAYS(TODAY(), End@row)),"")

1 ·